<?php


/* Connect using SQL Server Authentication. */
$connectionInfo = array( "UID"=>'sa',
                         "PWD"=>'vietgiaitri',
                         "Database"=>"doisoat",
						 "CharacterSet" => "UTF-8");

$conn = sqlsrv_connect('SERVER\SQLEXPRESS', $connectionInfo);
if( $conn === false )
{
     echo "Unable to connect.</br>";
     die( print_r( sqlsrv_errors(), true));
}

/* Query SQL Server for the login of the user accessing the
database. */
$tsql = "SELECT * FROM www_users";
$stmt = sqlsrv_query( $conn, $tsql);
if( $stmt === false )
{
     echo "Error in executing query.</br>";
     die( print_r( sqlsrv_errors(), true));
}
echo 'test php_sqlsrv_53_ts_vc6.dll';
/* Retrieve and display the results of the query. */
$row = sqlsrv_fetch_array($stmt);
print_r($row);

/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);

?>